package com.dzt.androidframework.database.dao;

/**
 * Created by M02323 on 2017/11/13.
 */

public class SQL {
	//V1.0
	public static final String TB_TASKS = "tb_tasks";
	//V2.0
	public static final String TB_TEST = "tb_test";
	//V3.0
	public static final String TB_EXPRESS = "tb_express";

	public static final String ID = "_id";
	public static final String TITLE = "title";
	public static final String DESCRIPTION = "description";
	public static final String COMPLETED = "completed";
	public static final String[] allTaskColumns = {ID, TITLE, DESCRIPTION, COMPLETED};
	public static final String CREATE_TASK_TABLE = "create table if not exists " + TB_TASKS + "(" +
			ID + " integer primary key," +
			TITLE + " varchar," +
			DESCRIPTION + " varchar," +
			COMPLETED + " integer" + ")";

	public static final String CREATE_TASK_TEST_TABLE = "create table if not exists " + TB_TEST + "(" +
			ID + " integer primary key," +
			DESCRIPTION + " varchar," +
			COMPLETED + " integer" + ")";

	public static final String EXPRESS_ID = "_id";   //必须的
	public static final String EXPRESS_NUMBER = "number";
	public static final String EXPRESS_COMPANY = "company";
	public static final String EXPRESS_STATE = "state";
	public static final String EXPRESS_TIME = "time";
	public static final String EXPRESS_SELECT = "isselect";
	public static final String[] allExpressColumns = {EXPRESS_ID, EXPRESS_NUMBER, EXPRESS_COMPANY,
			EXPRESS_STATE, EXPRESS_TIME, EXPRESS_SELECT};
	public static final String CREATE_EXPRESS_TABLE = "create table if not exists " + TB_EXPRESS
			+ "("
			+ EXPRESS_ID + " integer primary key autoincrement, "
			+ EXPRESS_NUMBER + " varchar, "
			+ EXPRESS_COMPANY + " varchar, "
			+ EXPRESS_STATE + " varchar, "
			+ EXPRESS_TIME + " varchar, "
			+ EXPRESS_SELECT + " integer " + ");";
}
